﻿using System;
using System.Data;
using System.Text;
using System.Data.SqlClient;
using CarFrameWork.Common;
namespace CarFrameWork.Model.CanShuHua
{
    /// <summary>
    /// 类磁性放油塞。
    /// </summary>
    [Serializable]
    public partial class 磁性放油塞
    {
        public 磁性放油塞()
        { }
        #region Model
        private int _id;
        private string _name;
        private string _path;
        private float _d1;
        private float _d2;
        private float _b1;
        private float _l1;
        private float _l3;
        private float _l5;
        /// <summary>
        /// 
        /// </summary>
        public int ID
        {
            set { _id = value; }
            get { return _id; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string name
        {
            set { _name = value; }
            get { return _name; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string path
        {
            set { _path = value; }
            get { return _path; }
        }
        /// <summary>
        /// 
        /// </summary>
        public float D1
        {
            set { _d1 = value; }
            get { return _d1; }
        }
        /// <summary>
        /// 
        /// </summary>
        public float D2
        {
            set { _d2 = value; }
            get { return _d2; }
        }
        /// <summary>
        /// 
        /// </summary>
        public float B1
        {
            set { _b1 = value; }
            get { return _b1; }
        }
        /// <summary>
        /// 
        /// </summary>
        public float L1
        {
            set { _l1 = value; }
            get { return _l1; }
        }
        /// <summary>
        /// 
        /// </summary>
        public float L3
        {
            set { _l3 = value; }
            get { return _l3; }
        }
        /// <summary>
        /// 
        /// </summary>
        public float L5
        {
            set { _l5 = value; }
            get { return _l5; }
        }
        #endregion Model


        #region  Method

        /// <summary>
        /// 得到一个对象实体
        /// </summary>
        public 磁性放油塞(int ID)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select ID,name,path,D1,D2,B1,L1,L3,L5 ");
            strSql.Append(" FROM [磁性放油塞] ");
            strSql.Append(" where ID=@ID ");
            SqlParameter[] parameters = {
					new SqlParameter("@ID", SqlDbType.Int,4)};
            parameters[0].Value = ID;

            DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
            if (ds.Tables[0].Rows.Count > 0)
            {
                if (ds.Tables[0].Rows[0]["ID"] != null && ds.Tables[0].Rows[0]["ID"].ToString() != "")
                {
                    this.ID = int.Parse(ds.Tables[0].Rows[0]["ID"].ToString());
                }
                if (ds.Tables[0].Rows[0]["name"] != null && ds.Tables[0].Rows[0]["name"].ToString() != "")
                {
                    this.name = ds.Tables[0].Rows[0]["name"].ToString();
                }
                if (ds.Tables[0].Rows[0]["path"] != null && ds.Tables[0].Rows[0]["path"].ToString() != "")
                {
                    this.path = ds.Tables[0].Rows[0]["path"].ToString();
                }
                if (ds.Tables[0].Rows[0]["D1"] != null && ds.Tables[0].Rows[0]["D1"].ToString() != "")
                {
                    this.D1 = float.Parse(ds.Tables[0].Rows[0]["D1"].ToString());
                }
                if (ds.Tables[0].Rows[0]["D2"] != null && ds.Tables[0].Rows[0]["D2"].ToString() != "")
                {
                    this.D2 = float.Parse(ds.Tables[0].Rows[0]["D2"].ToString());
                }
                if (ds.Tables[0].Rows[0]["B1"] != null && ds.Tables[0].Rows[0]["B1"].ToString() != "")
                {
                    this.B1 = float.Parse(ds.Tables[0].Rows[0]["B1"].ToString());
                }
                if (ds.Tables[0].Rows[0]["L1"] != null && ds.Tables[0].Rows[0]["L1"].ToString() != "")
                {
                    this.L1 = float.Parse(ds.Tables[0].Rows[0]["L1"].ToString());
                }
                if (ds.Tables[0].Rows[0]["L3"] != null && ds.Tables[0].Rows[0]["L3"].ToString() != "")
                {
                    this.L3 = float.Parse(ds.Tables[0].Rows[0]["L3"].ToString());
                }
                if (ds.Tables[0].Rows[0]["L5"] != null && ds.Tables[0].Rows[0]["L5"].ToString() != "")
                {
                    this.L5 = float.Parse(ds.Tables[0].Rows[0]["L5"].ToString());
                }
            }
        }

        /// <summary>
        /// 得到最大ID
        /// </summary>
        public int GetMaxId()
        {

            return DbHelperSQL.GetMaxID("ID", "磁性放油塞");
        }

        /// <summary>
        /// 是否存在该记录
        /// </summary>
        public bool Exists(int ID)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select count(1) from [磁性放油塞]");
            strSql.Append(" where ID=@ID ");

            SqlParameter[] parameters = {
					new SqlParameter("@ID", SqlDbType.Int,4)};
            parameters[0].Value = ID;

            return DbHelperSQL.Exists(strSql.ToString(), parameters);
        }


        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add()
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("insert into [磁性放油塞] (");
            strSql.Append("name,path,D1,D2,B1,L1,L3,L5)");
            strSql.Append(" values (");
            strSql.Append("@name,@path,@D1,@D2,@B1,@L1,@L3,@L5)");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters = {
					new SqlParameter("@name", SqlDbType.NVarChar,50),
					new SqlParameter("@path", SqlDbType.NVarChar),
					new SqlParameter("@D1", SqlDbType.Float,8),
					new SqlParameter("@D2", SqlDbType.Float,8),
					new SqlParameter("@B1", SqlDbType.Float,8),
					new SqlParameter("@L1", SqlDbType.Float,8),
					new SqlParameter("@L3", SqlDbType.Float,8),
					new SqlParameter("@L5", SqlDbType.Float,8)};
            parameters[0].Value = name;
            parameters[1].Value = path;
            parameters[2].Value = D1;
            parameters[3].Value = D2;
            parameters[4].Value = B1;
            parameters[5].Value = L1;
            parameters[6].Value = L3;
            parameters[7].Value = L5;

            object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
            if (obj == null)
            {
                return 0;
            }
            else
            {
                return Convert.ToInt32(obj);
            }
        }
        /// <summary>
        /// 更新一条数据
        /// </summary>
        public bool Update()
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("update [磁性放油塞] set ");
            strSql.Append("name=@name,");
            strSql.Append("path=@path,");
            strSql.Append("D1=@D1,");
            strSql.Append("D2=@D2,");
            strSql.Append("B1=@B1,");
            strSql.Append("L1=@L1,");
            strSql.Append("L3=@L3,");
            strSql.Append("L5=@L5");
            strSql.Append(" where ID=@ID ");
            SqlParameter[] parameters = {
					new SqlParameter("@name", SqlDbType.NVarChar,50),
					new SqlParameter("@path", SqlDbType.NVarChar),
					new SqlParameter("@D1", SqlDbType.Float,8),
					new SqlParameter("@D2", SqlDbType.Float,8),
					new SqlParameter("@B1", SqlDbType.Float,8),
					new SqlParameter("@L1", SqlDbType.Float,8),
					new SqlParameter("@L3", SqlDbType.Float,8),
					new SqlParameter("@L5", SqlDbType.Float,8),
					new SqlParameter("@ID", SqlDbType.Int,4)};
            parameters[0].Value = name;
            parameters[1].Value = path;
            parameters[2].Value = D1;
            parameters[3].Value = D2;
            parameters[4].Value = B1;
            parameters[5].Value = L1;
            parameters[6].Value = L3;
            parameters[7].Value = L5;
            parameters[8].Value = ID;

            int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
            if (rows > 0)
            {
                return true;
            }
            else
            {
                return false;
            }
        }

        /// <summary>
        /// 删除一条数据
        /// </summary>
        public bool Delete(int ID)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("delete from [磁性放油塞] ");
            strSql.Append(" where ID=@ID ");
            SqlParameter[] parameters = {
					new SqlParameter("@ID", SqlDbType.Int,4)};
            parameters[0].Value = ID;

            int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
            if (rows > 0)
            {
                return true;
            }
            else
            {
                return false;
            }
        }


        /// <summary>
        /// 得到一个对象实体
        /// </summary>
        public void GetModel(int ID)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select ID,name,path,D1,D2,B1,L1,L3,L5 ");
            strSql.Append(" FROM [磁性放油塞] ");
            strSql.Append(" where ID=@ID ");
            SqlParameter[] parameters = {
					new SqlParameter("@ID", SqlDbType.Int,4)};
            parameters[0].Value = ID;

            DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
            if (ds.Tables[0].Rows.Count > 0)
            {
                if (ds.Tables[0].Rows[0]["ID"] != null && ds.Tables[0].Rows[0]["ID"].ToString() != "")
                {
                    this.ID = int.Parse(ds.Tables[0].Rows[0]["ID"].ToString());
                }
                if (ds.Tables[0].Rows[0]["name"] != null && ds.Tables[0].Rows[0]["name"].ToString() != "")
                {
                    this.name = ds.Tables[0].Rows[0]["name"].ToString();
                }
                if (ds.Tables[0].Rows[0]["path"] != null && ds.Tables[0].Rows[0]["path"].ToString() != "")
                {
                    this.path = ds.Tables[0].Rows[0]["path"].ToString();
                }
                if (ds.Tables[0].Rows[0]["D1"] != null && ds.Tables[0].Rows[0]["D1"].ToString() != "")
                {
                    this.D1 = float.Parse(ds.Tables[0].Rows[0]["D1"].ToString());
                }
                if (ds.Tables[0].Rows[0]["D2"] != null && ds.Tables[0].Rows[0]["D2"].ToString() != "")
                {
                    this.D2 = float.Parse(ds.Tables[0].Rows[0]["D2"].ToString());
                }
                if (ds.Tables[0].Rows[0]["B1"] != null && ds.Tables[0].Rows[0]["B1"].ToString() != "")
                {
                    this.B1 = float.Parse(ds.Tables[0].Rows[0]["B1"].ToString());
                }
                if (ds.Tables[0].Rows[0]["L1"] != null && ds.Tables[0].Rows[0]["L1"].ToString() != "")
                {
                    this.L1 = float.Parse(ds.Tables[0].Rows[0]["L1"].ToString());
                }
                if (ds.Tables[0].Rows[0]["L3"] != null && ds.Tables[0].Rows[0]["L3"].ToString() != "")
                {
                    this.L3 = float.Parse(ds.Tables[0].Rows[0]["L3"].ToString());
                }
                if (ds.Tables[0].Rows[0]["L5"] != null && ds.Tables[0].Rows[0]["L5"].ToString() != "")
                {
                    this.L5 = float.Parse(ds.Tables[0].Rows[0]["L5"].ToString());
                }
            }
        }

        /// <summary>
        /// 获得数据列表
        /// </summary>
        public DataSet GetList(string strWhere)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select * ");
            strSql.Append(" FROM [磁性放油塞] ");
            if (strWhere.Trim() != "")
            {
                strSql.Append(" where " + strWhere);
            }
            return DbHelperSQL.Query(strSql.ToString());
        }

        #endregion  Method
    }
}